void COdbcView::ListBuild()
{
	CMainFrame *pMainFrame=(CMainFrame *) AfxGetMainWnd();
	CLeftView * pLeftView = pMainFrame->GetLeftPane();
	CTreeCtrl &refTree = pLeftView->GetTreeCtrl();

	CString  strMess = "ڲѯԺ...";
	pMainFrame->m_wndStatusBar.SetPaneText(1,strMess);

	CDatabase db;
	CGsqkSet* pGsqkSet = new CGsqkSet(&db);

	CString strCpbm;
	
	int param = pLeftView->m_nCurlParam;

	switch(pLeftView->m_nCurlParam)
	{
	case 0:
		if( pMainFrame->m_strDqbm != "0000" )	
			pGsqkSet->m_strFilter =  "FGsbm Like '" + pMainFrame->m_strDqbm +"%%%'";
		break;
	case 1:
		strCpbm = pLeftView->m_strCpbm.Left(1);
		if( pMainFrame->m_strDqbm == "0000" )
		{
			pGsqkSet->m_strFilter =  "FGsbm in (select distinct fgsbm from cpqk where fcpbm like '" + strCpbm +"%%%')";
		}
		else
		{
			pGsqkSet->m_strFilter =  "FGsbm in (select distinct fgsbm from cpqk where (fcpbm like '" + strCpbm +"%%%' AND FGsbm Like '" + pMainFrame->m_strDqbm +"%%%'))";
		}
		break;
	case 2:
		strCpbm = pLeftView->m_strCpbm.Left(2);
		if( pMainFrame->m_strDqbm == "0000" )
		{
			pGsqkSet->m_strFilter =  "FGsbm in (select distinct fgsbm from cpqk where fcpbm like '" + strCpbm +"%%')";
		}
		else
		{
			pGsqkSet->m_strFilter =  "FGsbm in (select distinct fgsbm from cpqk where (fcpbm like '" + strCpbm +"%%' AND FGsbm Like '" + pMainFrame->m_strDqbm +"%%%'))";
		}
		break;
	case 3:
		strCpbm = pLeftView->m_strCpbm;
		if( pMainFrame->m_strDqbm == "0000" )
		{
			pGsqkSet->m_strFilter =  "FGsbm in (select distinct fgsbm from cpqk where fcpbm = '" + strCpbm +"')";
		}
		else
		{
			pGsqkSet->m_strFilter =  "FGsbm in (select distinct fgsbm from cpqk where (fcpbm = '" + strCpbm + "' AND FGsbm Like '" + pMainFrame->m_strDqbm +"%%%'))";
		}
		break;
	}

	if( !pGsqkSet->IsOpen() )
		int a = pGsqkSet->Open();

	if(!pGsqkSet->IsBOF())
		pGsqkSet->MoveFirst();

    CListCtrl &refList = GetListCtrl();
	refList.DeleteAllItems();   //ɾб
    int nItemNumber = 0;
	while(!pGsqkSet->IsEOF())
	{
		CString gsbm =  pGsqkSet->m_fgsbm;
		refList.InsertItem(nItemNumber,pGsqkSet->m_fgsbm);
		refList.SetItemText(nItemNumber,1,pGsqkSet->m_fgsmc);
		refList.SetItemText(nItemNumber,2,pGsqkSet->m_flxdh);
		refList.SetItemText(nItemNumber,3,pGsqkSet->m_fyzbm);
		refList.SetItemText(nItemNumber,4,pGsqkSet->m_ftxdz);
		nItemNumber++;

		pGsqkSet->MoveNext();
	}
	
	pGsqkSet->Close();
	delete pGsqkSet;

}
